<?php

namespace App\Http\Controllers\Admin;

use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use App\Models\WaterMyStorage;

class MyStorageController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        $perPage = $request->input('pageSize',15);
        $query = WaterMyStorage::query();
        
        $shopId = $request->input('shop_id', 0);
        if(!empty($shopId)) {
            $query->where('shop_id', $shopId);
        }
        $cid = $request->input('company_id', '');
        if(!empty($cid)) {
            $query->where('company_id', $cid);
        }
        $sid = $request->input('site', '');
        if(!empty($sid)) {
            $query->where('site_id', $sid);
        }
        
        $created = $request->input('created_at', []);
        if(!empty($created)) {
            $query->whereBetween('created_at', $created);
        }
        
        $query->with([
            'companies' => function($query) {
                $query->select(['Co_ID', 'Co_Name']);
            },
            'sites' => function($query) {
                $query->select(['id', 'name']);
            },
            'shop'=> function($query) {
                $query->select(['id', 'name', "unit"]);
            },
        ]);
        $list = $query->paginate($perPage);
        return $list;
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        //
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        //
    }
}
